Help with formula

[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!!!

 

[Sixthsense]

May be this…
=IF(D3<>Sheet1!G1,((E3*0.0425)+(E3*0.0217)+(E3*0.0204)+(E3*0.085))/
C3,F3)

 

[joeu2004]

May be this…
=IF(D3<>Sheet1!G1,
((E3*0.0425)+(E3*0.0217)+(E3*0.0204)+(E3*0.085))/
C3,F3)

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

=IF(D3<>Sheet1!G1, E3*0.1696/C3 F3)

 

[joeu2004]

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.

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?

 

[Sixthsense]

Hi Joe,

Yes, you are right!

Your post made smile on my face .