Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Functions
=IF(L721,F72,0)+SUMIF(L70:L71,"<0",F70:F71)
Just change the L71 and F71 to your final row. -- __________________________________ HTH Bob "Roachy" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Functions
Hi
I'm not really understanding your problem. Your statement says if L71=0, add F71, but your text says (if the value of L71 doesn't = 0) Instead of Multiple If's you could use =IF(L721,F72+F71*(L71<0)+F70*(L70<0) ....... ,"") the sting of dots ... is for you to add as many other expressions of the type shown, with the final ,"" representing what you want to happen if L72 is not 1. Each Expression F71*(L71<0) will evaluate to either the value in F71 if L71<0 or 0 if it is not. -- Regards Roger Govier "Roachy" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Functions
Cheers Bob worked a treat
"Bob Phillips" wrote: =IF(L721,F72,0)+SUMIF(L70:L71,"<0",F70:F71) Just change the L71 and F71 to your final row. -- __________________________________ HTH Bob "Roachy" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula/functions for average and if functions | Excel Worksheet Functions | |||
XL2003 FILTER FUNCTIONS VS. XL2007 FILTER FUNCTIONS | Excel Worksheet Functions | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Looking for a site with functions that substitute the ATP functions | Excel Worksheet Functions | |||
Nesting functions in the functions dialog box | Excel Worksheet Functions |