Forum Discussion
Trav1017
Dec 28, 2021Copper Contributor
FORMULAS AND FUNCTIONS
=D3+F3+H3+J3+$U$13 I want to add if b3 is (PTO) THEN T13*N3 CAN I DO THAT AND HOW ?
HansVogelaar
Dec 28, 2021MVP
=IF(B3="PTO",T13*N3,D3+F3+H3+J3+$U$13)
Trav1017
Dec 28, 2021Copper 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
IF B3 IS PTO I WANT BASICLY CANCEL =D3+F3+H3+J3+$U$13
AND DO =T13*N3
- HansVogelaarDec 29, 2021MVP
That's what the formula in my previous reply does.