Help combine 2 formulas into 1


G

Guest

I am dumbfounded. Just could not do it to combine the following
2 formulas in cols I and J into 1 formula in col J.
Cell I5
=IF(F5<0,(INT(F5/D5)*-D5),0)
Cell J5
=if( I5>E5,E5,I5)

Thank you.
RobertR
 
Ad

Advertisements

J

JulieD

Hi Robert

try
=IF(IF(F5<0,(INT(F5/D5)*-D5),0)>E5,E5,IF(F5<0,(INT(F5/D5)*-D5),0))

Cheers
JulieD
 
M

Myrna Larson

With nothing in I5 and this formula in J5:

=MIN(E5,IF(F5<0,(INT(F5/D5)*-D5),0))
 
J

JulieD

you're welcome and thanks for the feedback (hope you went with Myrna's it's
an awful lot less typing than mine!)
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top