Thread: Making info appear in another cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
samprince samprince is offline
external usenet poster
  
Posts: 1
Default Making info appear in another cell

i'd set the excel up so that you have in Column A the Job Undertaken
then the next columns the name of the job.
Column A ColumnB Column C
Job Undertaken, Walk Groom etc

In COlumn A you woudl enter what job was done,

in Coumn B, =IF($A2="Walk","$10","$0")
in Column C, =IF($A2="Groom","$15","$0")

Then Fill them down, so in each column a value would appear dependant
on what was entered into Column A. You Sum them at the bottom then
without having to do a pivot table.


--
samprince
------------------------------------------------------------------------
samprince's Profile: http://www.excelforum.com/member.php...o&userid=34168
View this thread: http://www.excelforum.com/showthread...hreadid=567383

Reply With QuoteReply With Quote