Forum Discussion

Trav1017's avatar
Trav1017
Copper Contributor
Dec 28, 2021

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 ?
Formulas and Functions
Trav1017's avatar
Trav1017
Copper Contributor
Dec 28, 2021

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's avatar
    Trav1017
    Copper Contributor
    Dec 28, 2021
    =D3+F3+H3+J3+$U$13
    IF B3 IS PTO I WANT BASICLY CANCEL =D3+F3+H3+J3+$U$13
    AND DO =T13*N3
    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Dec 29, 2021

      Trav1017 

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

Resources