Forum Discussion
Gemma_Strachan
Dec 13, 2023Copper Contributor
HELP! IF formula with Multiple Considerations
Hello, I am looking for some help on typing a formula which takes multiple considerations. I have 3 cells which I am looking up across, average, Band and HOD - some of the information is N/A ...
Gemma_Strachan
Dec 13, 2023Copper Contributor
I basically need it to come out with a specific number from the 3
A = 100
b = 200
c = 300
If a Is higher than B I use A, but if C is higher than A then I use C - but if either Cell has an N/A (namely A and C) I dont know how to do the calc so It shows the number
A = 100
b = 200
c = 300
If a Is higher than B I use A, but if C is higher than A then I use C - but if either Cell has an N/A (namely A and C) I dont know how to do the calc so It shows the number