G
Gee
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.
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.