Formulas and Functions

Copper Contributor

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

 

CAN I DO THAT AND HOW?

3 Replies

 

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

 

or am I misunderstanding your question?

DOESNOT WORK BUT I THINK WE ARE GETTING SOMEWHERE LOL SO
SO IF B3="PTO" THEN T13*N3
BUT IF B3= ANY NUMBER I WANT =D3+F3+H3+J3+$U$13
what if B3 is not "PTO" nor a number?
=IFS(B3="PTO",ISNUMBER(B3),T13*N3,D3+F3+H3+J3+$U$13,TRUE,"")