FORMULAS AND FUNCTIONS

Question

=D3+F3+H3+J3+$U$13&nbsp;&nbsp;I want to add if b3 is (PTO) THEN T13*N3&nbsp;CAN I DO THAT AND HOW ?

hansvogelaar · Answer

Trav1017&nbsp;
=D3+F3+H3+J3+$U$13+IF(B3="(PTO)",T13*N3,0)
&nbsp;
or
&nbsp;
=D3+F3+H3+J3+$U$13+(B3="(PTO)")*T13*N3

trav1017 · Answer

DID NOT WORK MAY HAVE WORDED THE QUESTION WRONGK3=D3+F3+H3+J3+$U$13&nbsp;if b3 is PTO THEN K3=T13*N3

hansvogelaar · Answer

Trav1017&nbsp;
=IF(B3="PTO",T13*N3,D3+F3+H3+J3+$U$13)

trav1017 · Answer

=D3+F3+H3+J3+$U$13IF B3 IS PTO I WANT BASICLY CANCEL =D3+F3+H3+J3+$U$13AND DO =T13*N3

hansvogelaar · Answer

Trav1017&nbsp;
That's what the formula in my previous reply does.

Forum Discussion