I am trying to create a formula for the following: Total no. of days: 3 (Cell: A1)

Cost for first 5 days: <formula> (Cell: A2)<formula>: I want a formula that could capture A1, numbers ranging from 1 to 5. If A1 has a number more than 5, A2 should remain to 5 because the cost is calculated for only the first 5 days.

Any help would be greatly appreciated.

message edited by MisterWann

The IF function has this syntax: =IF(logical_test, value_if_true, value_if_false)

=IF(A1>5, 5,

insert your formula for when A1<=5)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03

Ask Your Question

Weekly Poll

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History