Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jc jc is offline
external usenet poster
 
Posts: 164
Default If(and formula help please

IF AND FORMULA HELP FOR the following scenarios


I have four columns with data
example
row# AD AE AG AH AI
1 12 22 133.00 140.00 data in all columns so AE row2
should be =" "
" " "" " " " "
12 122.00 0 no data in AE so row2 should be
" " 1 " " " "
15 0 144.00 no data in AE
1 " " "" " "
blank blank blank blank no data in all row
" " " " " " " "


Reply
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



All times are GMT +1. The time now is 12:53 PM.

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"