formula

[Anne White]

I am trying to create a formula that does the following:

if one cell (b4) is grater than or equal to another cell
(b1) than multilpy cell (b4) by 5%. I can't figure how to
do this or what I am doing wrong. This is what I have put:

IF B4>=B1,B4*5% OR IFSUM(B3+c3)>=B1,85% OR

I keep getting errors. If anyone can help, it would be
much appreciated. Thanks

Anne White

 

[Naraine]

Please try,

=IF(B4>=B1,B4*5%,B4)

=IF(B3+C3)>=B1,(B3+C3)*85%,(B3+C3)

 

[Frank Kabel]

Hi Anne
try
=IF(B4>=B1,B4*0.05,"don't know")

not sure what should happen if B4<B1

 

[Bill Kuunders]

enter in for instance cell E4...............

=IF(B4>=B1,B4*1.05,"")
regards
Bill K