Minimum IF Statements
That did it!
Thanks so much!
"Elkar" wrote:
Try this:
=IF(B70,MAX(20,B7*.18),"")
HTH
Elkar
"Gee" wrote:
This is what I'm trying to do:
In Cell C8:
If B7 is greater than 0 then B7*.18, if the sum of B7*.18 is < 20 then 20,
else B7*.18
Does that make sense? I want to formula to fire if there is an entry in B7,
that will give a minimum of 20 or the sum of B7*.18
Thank you in advance for any help.
|