View Single Post
  #1  
Old 08-17-2007, 10:54 AM
jswarb001 jswarb001 is offline
Registered User
 
Join Date: 09 Jul 2007
Posts: 28
jswarb001 is an unknown quantity at this point
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
Reply With Quote