Originally Posted by jswarb001

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