If there is value in one column then a $ generates in another [Closed]

Report
Posts
1
Registration date
Thursday June 6, 2013
Status
Member
Last seen
June 6, 2013
-
Posts
2742
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 4, 2021
-
Hi there,

I am trying to create an excel formular where in Column G I have a drop down menu with either Long Hire or Single Hire as the options. When someone selects the Long Hire in Column G I want it to populate with a rate in column H and when they select Single Hire I want it to populate with a different rate in column H.

Single Hire 40
Long Hire 120

Does anyone know the best way for me to achieve this please?

Cheers,
Jess

1 reply

Posts
2742
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 4, 2021
460
Hi KiwiJess,

Column H would contain:
=IF(G2="Single Hire",40,120)

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!