|
Multiple If Formula
Hello Iwonder if you can help with following scenario in constructing an IF formula:
If the figure in cell L8 is greater than 37.5 , then in cell P8 enter the difference (ie L8-37.5). But if the figure in C8 happens to be 40, then show the difference in P8 as L8- C8 instead providing it exceeds 0.
I can do the first bit but cant get the second arguement to work.
manythanks for any help
|