FORMULAS AND FUNCTIONS

Copper Contributor

=D3+F3+H3+J3+$U$13 

 

I want to add if b3 is (PTO) THEN T13*N3

 

CAN I DO THAT AND HOW ?

5 Replies

@Trav1017 

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

 

or

 

=D3+F3+H3+J3+$U$13+(B3="(PTO)")*T13*N3

DID NOT WORK MAY HAVE WORDED THE QUESTION WRONG

K3=D3+F3+H3+J3+$U$13 

if b3 is PTO THEN K3=T13*N3

@Trav1017 

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

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

@Trav1017 

That's what the formula in my previous reply does.