ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   If(and formula help please (https://www.excelbanter.com/excel-worksheet-functions/188665-if-formula-help-please.html)

jc

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
" " " " " " " "




All times are GMT +1. The time now is 04:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com