Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If formula
I am stuck trying to figure out a formula to use for my calculation. I'll try
to explain it the best I can. Here is what I have so far: =if(F34=0,L34+F35,L35-F35). This formula works just fine but I need to add another 'if' formula that has: if L34=0 and F34=0 then use F35-L35. I just started doing formulas yesterday so sorry if this one is really simple and I'm just overlooking something. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If formula
dualshock wrote:
I am stuck trying to figure out a formula to use for my calculation. I'll try to explain it the best I can. Here is what I have so far: =if(F34=0,L34+F35,L35-F35). This formula works just fine but I need to add another 'if' formula that has: if L34=0 and F34=0 then use F35-L35. There are many ways to do anything. One way to accomplish what you seem to want is: =if(F34=0, if(L34=0, F35-L35, L34+F35), L35-F35) PS: Should "L34+F35" [sic] be L35+F35? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If formula
Try: IF(AND(L34=0,F34=0),F35-L35, IF(F34=0,L34+F35,L35-F35)). HTH -- Casey ------------------------------------------------------------------------ Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545 View this thread: http://www.excelforum.com/showthread...hreadid=559402 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If formula
Thank you! This is exactly what I was trying to get.
"Casey" wrote: Try: IF(AND(L34=0,F34=0),F35-L35, IF(F34=0,L34+F35,L35-F35)). HTH -- Casey ------------------------------------------------------------------------ Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545 View this thread: http://www.excelforum.com/showthread...hreadid=559402 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If formula
=if(F34=0,IF(L34=0,-L35,L34)+F35,L35-F35)
"dualshock" wrote: I am stuck trying to figure out a formula to use for my calculation. I'll try to explain it the best I can. Here is what I have so far: =if(F34=0,L34+F35,L35-F35). This formula works just fine but I need to add another 'if' formula that has: if L34=0 and F34=0 then use F35-L35. I just started doing formulas yesterday so sorry if this one is really simple and I'm just overlooking something. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |