BuildPro

3 years agoQrew Captain

# Need assistance with formula please

I know there are several thing wrong with this, but I wanted to make sure you knew what I was trying to accomplish. thank you

If

([Start - Hang]<Date(2021,7,26) and [Paint Garage]=true,

[BOARD COUNT]*[DW PT/UP (1) SLP],

[BD CT PT/UP]*[DW PT/UP (1) SLP],

If

([Start - Hang]>Date(2021,7,26) and [Paint Garage]=true,

([BOARD COUNT]*[DW PT/UP (1) SLP])+([BOARD COUNT]*[DW PT/UP (2) SLP]),

([BD CT PT/UP]*[DW PT/UP (1) SLP])+([BD CT PT/UP]*[DW PT/UP (2) SLP]))

------------------------------

Lynne8817 Lynne8817

------------------------------

If

([Start - Hang]<Date(2021,7,26) and [Paint Garage]=true,

[BOARD COUNT]*[DW PT/UP (1) SLP],

[BD CT PT/UP]*[DW PT/UP (1) SLP],

If

([Start - Hang]>Date(2021,7,26) and [Paint Garage]=true,

([BOARD COUNT]*[DW PT/UP (1) SLP])+([BOARD COUNT]*[DW PT/UP (2) SLP]),

([BD CT PT/UP]*[DW PT/UP (1) SLP])+([BD CT PT/UP]*[DW PT/UP (2) SLP]))

------------------------------

Lynne8817 Lynne8817

------------------------------