Help with formula

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I need to change this formula to include 3 more numbers.
=IF(D3<>Sheet1!G1,E3*.0425/C3,F3)
I need to also have .0217 and .0204 and .0850 in this formula. Is this
possible? any help at all! Thanks in advance!!!
 
May be this…
=IF(D3<>Sheet1!G1,((E3*0.0425)+(E3*0.0217)+(E3*0.0204)+(E3*0.085))/
C3,F3)
 
Sixthsense said:
May be this…
=IF(D3<>Sheet1!G1,
((E3*0.0425)+(E3*0.0217)+(E3*0.0204)+(E3*0.085))/
C3,F3)
Click to expand...

If that's the right solution, why not simply:

=IF(D3<>Sheet1!G1, E3*0.1696/C3 F3)
 
Bob said:
I need to change this formula to include 3 more numbers.
=IF(D3<>Sheet1!G1,E3*.0425/C3,F3)
I need to also have .0217 and .0204 and .0850 in this
formula.
Click to expand...

We're not mindreaders, Bob. You need to tell us __how__ you want "to
include 3 more numbers". The possibilities are almost endless.

Do you want to substitute 0.0217, 0.0204 and 0.0850 in place of 0.0425 based
on some conditions? If so, what conditions?

Or do you want some arithmetic combination those 4 numbers? If so, exactly
how?
 
Back
Top