Creating an IF formula to return values It would look something like this =IF(B1 EQUALS NUMERIC VALUE then NUMERIC VALUE
Posted: Thu Jul 14, 2022 2:11 pm
Creating an IF formula to return values
It would look something like this
=IF(B1 EQUALS NUMERIC VALUE then NUMERIC VALUE DIVIDED BY .70,IF A1 EQUALS TEXT, then A1 Divided by .70)
It would look something like this
=IF(B1 EQUALS NUMERIC VALUE then NUMERIC VALUE DIVIDED BY .70,IF A1 EQUALS TEXT, then A1 Divided by .70)