LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 39
Default Multiple Functions of a Cell

I'm trying to use this spread sheet for purchasing fuel and to subtract the
fuel tax from the pump price when I purchase fuel so if I type in cell B2 IL
I want $0.43 to show up in Cell C2 but... If I type IN in cell B2 I want
$0.16 to show up in Cell C2 and so on for all the States I buy fuel in
=IF(C2="IL",0.43,0) if I type this in Cell C2 that is good for IL but I can't
seem to do a multiple =IF in the same Cell
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple functions in one cell cgroninger Excel Worksheet Functions 4 May 9th 08 04:04 PM
multiple functions on one cell ? Tim R Excel Discussion (Misc queries) 6 October 24th 07 09:40 AM
Multiple functions in a cell help Mikjall777 New Users to Excel 5 August 11th 06 02:23 PM
MUltiple functions on a same cell harshaputhraya Excel Discussion (Misc queries) 1 May 8th 06 06:28 AM
Multiple functions per cell? excelnewbie Excel Worksheet Functions 6 September 19th 05 09:33 AM


All times are GMT +1. The time now is 05:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"