Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Simple Formula (I thought)
Been racking my brains all day on this, I'm sure one of you clever people out there can help me. I need to do a simple calculation based on hourly rates, example as follows. TA bills out at $20 an hour MF bills out at $50 an hour FG bills out at $70 an hour All the above are in the same column of a worksheet....how the hell do I get a total for the above as a grand total. i.e. IF A1 = TA, do a calculation, add to total. IF A6 = MF do a calculation add to total and so on. The initials are in drop down boxes....and the input needs to be simple cos numptys like me have to do this... :) Any help would be very appreciated. Chris AKA Excel virgin -- csandi ------------------------------------------------------------------------ csandi's Profile: http://www.excelforum.com/member.php...o&userid=28809 View this thread: http://www.excelforum.com/showthread...hreadid=484973 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
simple MAX + comparison formula | Excel Worksheet Functions | |||
Simple (I Think) Date Formula Needed | Excel Discussion (Misc queries) | |||
simple formula | Excel Worksheet Functions | |||
help with simple addition formula | Excel Worksheet Functions | |||
simple formula help | Excel Worksheet Functions |