If statement
I think this formula does what you want...
=IF(AG360,MAX(0,AG36-AL28),AL28)
--
Rick (MVP - Excel)
"meggie" wrote in message
...
Hi Everyone,
I am having trouble getting my formula to follow my logic!
I want the cell to follow the logic of:
If AG360,then enter AL28-AG36,however if AL28-AG36<0 then enter 0
I currently have
=IF(AG360,AG36-AL28,AL28), IF(AG36-AL28<0,0,AG36-AL28)
My logic is not following how it should be and I am getting a Value error.
Thanks in advance!
Cheers,
Meg
|