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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 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

If there is value in one column then a $ generates in another
Display two columns in data validation list but return only one - Guide
How to delete column in word - Guide
Excel copy column from one sheet to another automatically - Guide
Tweetdeck remove column - Guide
Excel count occurrences of string in column - Guide

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Jun 10, 2013 at 10:46 AM

Hi KiwiJess,

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

Best regards,
Trowa

Similar discussions

Auto generate serial number in excel based on Column

Comparing columns and returning value

Converting rows of data in notepad to columns

VBA find column by name and sort

If a cell contains any text then add a value

Similar discussions

Subscribe To Our Newsletter!