entering multiple command formulas

L

lilprintesa1028

I need to enter a formula that will subtract two cells without getting a
negative, then divide that number by 2. Any suggestions?
 
K

ken-hup

Try this
=IF((A2>A1),0,IF(((A1-A2)/2)<0,0,A1-A2/2))

This will result in required answer or 0
 
K

ken-hup

Just to explain -
If A2 is greater than A1 put 0, if A2 is less than A1 try...
If A1-A2 divided by 2 is less than 0 put 0, if it is greater than 0
put answer of A1-A2 / 2

Hope this helps you understand "nested" IF statements
 

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

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Water meter readings 1
Excel does not accept text format! 0
Inventory List 3
Getting the difference between a "negative" number and a positive 2
formula 3
I'm sure its an easy answer.... 1
Formula for increasing a result to the next highest 1000 2

Top