Forum Discussion
Katy Baron
Nov 21, 2017Copper Contributor
Help with Formula - can you have a calculation in an IF formula?
Hi there,
I'm an excel novice and can only do simple formulas! I'm having difficulty doing a formula which is essentially:
If the cell A1 is R/O put 0.00 in, if it is B&B multiply cell...
Nov 21, 2017
Hi Katy,
This is the formula:
=IF(A1="R/O",0,IF(A1="B&B",A2*8.08,"N/A"))