LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 683
Default Multiple IF Statements

=IF(AND($F11="",$G11=""),"",IF(AND($F11="?",$G11=" ?"),"",IF(AND($F11=0,$G11=0),0,IF(OR($F110,$G110 ),(E11*F11)+(E11*G11/2)))))

I know these are multiple IF statements above, but I cant figure out what
the "" means?? eg. F11="". Does it mean if cell is blank then the cell with
this formula is blank ?

What about the "? " eg. F11="?". Does it mean if cell has any text in it
the the cell with this formula is blank ?

Thank for any feed back!

Brian
 
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 IF statements looking up multiple ranges. mike Excel Worksheet Functions 7 August 9th 07 04:55 PM
Multiple if statements with multiple conditions egarcia Excel Discussion (Misc queries) 4 January 29th 07 10:46 PM
Multiple IF Statements [email protected] Excel Discussion (Misc queries) 3 December 28th 06 02:33 PM
multiple if statements ddepasquale Excel Worksheet Functions 3 August 5th 05 09:55 PM
multiple IF statements Nathan McElmurry Excel Worksheet Functions 1 November 18th 04 09:22 PM


All times are GMT +1. The time now is 08: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"