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 Monopoly should update its pieces?

Discuss in The Lounge

Poll History