Thread: If formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sloth Sloth is offline
external usenet poster
 
Posts: 252
Default 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.