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

Closed
KiwiJess Posts 1 Registration date Thursday June 6, 2013 Status Member Last seen June 6, 2013 - Jun 6, 2013 at 11:06 PM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Jun 10, 2013 at 10:46 AM
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

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Jun 10, 2013 at 10:46 AM
Hi KiwiJess,

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

Best regards,
Trowa
0