Thread: IF Functions
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Roachy Roachy is offline
external usenet poster
 
Posts: 9
Default IF Functions

Probabally a really simple question but Im looking to do my IF function in a
couple of stages firstly to check cell L72 and check if the value is greater
than 1 bringing back the value in F72 if true.

Then moves onto L71 and adds the value of F71 to the origional numbers above
(if the value of L71 doesnt = 0) and so on and so on....

=IF(L721,(F72+IF(L71=0,F71)+IF(L70=0,F70)))

Hope this makes sence

Please help