Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding FALSE message
This is the formula I'm using in the cell:
=IF(G2*1.33<D2,D2,IF(G2*1.33D2,G2*1.33)) Now.... if there is no data in that particular row, then the word FALSE is in that cell. Is there some way to make it so the cell is blank until I enter data? I'm almost done with this project and you've all been so helpful. Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding FALSE message
On Jan 9, 12:32*pm, wrote:
This is the formula I'm using in the cell: =IF(G2*1.33<D2,D2,IF(G2*1.33D2,G2*1.33)) Now.... if there is no data in that particular row, then the word FALSE is in that cell. *Is there some way to make it so the cell is blank until I enter data? You are missing the 3rd argument of the 2nd IF() function call. Change to: =IF(G2*1.33<D2,D2,IF(G2*1.33D2,G2*1.33,"")) Are you sure you truly want a blank in that case. I would think you want: =max(D2, G2*1.33) Alternatively, to give you exactly what you wrote: =if(G2*1.33=D2, "", max(D2,G2*1.33)) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding FALSE message
=IF(G2*1.33<D2,D2,IF(G2*1.33D2,G2*1.33,""))
Tyro wrote in message ... This is the formula I'm using in the cell: =IF(G2*1.33<D2,D2,IF(G2*1.33D2,G2*1.33)) Now.... if there is no data in that particular row, then the word FALSE is in that cell. Is there some way to make it so the cell is blank until I enter data? I'm almost done with this project and you've all been so helpful. Thank you. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding FALSE message
On Jan 9, 3:38*pm, joeu2004 wrote:
On Jan 9, 12:32*pm, wrote: This is the formula I'm using in the cell: =IF(G2*1.33<D2,D2,IF(G2*1.33D2,G2*1.33)) Now.... if there is no data in that particular row, then the word FALSE is in that cell. *Is there some way to make it so the cell is blank until I enter data? You are missing the 3rd argument of the 2nd IF() function call. Change to: =IF(G2*1.33<D2,D2,IF(G2*1.33D2,G2*1.33,"")) Are you sure you truly want a blank in that case. *I would think you want: =max(D2, G2*1.33) Alternatively, to give you exactly what you wrote: =if(G2*1.33=D2, "", max(D2,G2*1.33)) It worked... thank you so much... You guys are awesome!!!! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding FALSE message
On Jan 9, 12:38 pm, joeu2004 wrote:
On Jan 9, 12:32 pm, wrote: This is the formula I'm using in the cell: =IF(G2*1.33<D2,D2,IF(G2*1.33D2,G2*1.33)) Now.... if there is no data in that particular row, then the word FALSE is in that cell. Is there some way to make it so the cell is blank until I enter data? [....] =IF(G2*1.33<D2,D2,IF(G2*1.33D2,G2*1.33,"")) [....or....] =max(D2, G2*1.33) [....] =if(G2*1.33=D2, "", max(D2,G2*1.33)) You seem happy with one or more of the alternatives that I provided. But they were based on your original formula. When I reread what you truly wanted -- what a concept! -- namely blank when "there is no data in that particular row", I realized that you might have written the wrong formula in the first place. I suspect you truly want one of the following, depending on your requirements: =if(and(G2="",D2=""), "", max(D2, G2*1.33)) =if(or(G2="",D2=""), "", max(D2, G2*1.33)) The second formula requires data in both cells. The first formula requires data in only one cell, treating the remaining blank cell as zero.. That is, I suspect you actually do want zero, not blank, when D2 and G2 are both zero (as well as when D2 = G2*1.33). I suspect you merely stumbled onto the fact that when D2 and G2 are blank, D2=G2 is true because both are treated as zero, and you want blank in that case. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hiding #value message in cells | Excel Discussion (Misc queries) | |||
Hiding rows in a range based on TRUE/FALSE value in each row | Excel Discussion (Misc queries) | |||
Hiding vlookup message #N/A | Excel Worksheet Functions | |||
Hiding message boxes | Excel Discussion (Misc queries) | |||
hiding #DIV/0! message | Excel Discussion (Misc queries) |