| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
"False" filling in the blank spaces
I have used the following formula in a commission report.
=IF((D5<"")*(E5<""),LOOKUP(E5,{3,3.15,3.25,3.35, 3.45,3.55,3.65,3.75},{0.38,0.43,0.46,0.49,0.52,0.5 6,0.59,0.62})*D5-H5) When the spaces referenced above are blank i get a "false" in the blank. Can I change it so the false is blank to keep the sheet clean? |
|
#2
|
|||
|
|||
|
Try...
=IF((D5<"")*(E5<""),LOOKUP(E5,{3,3.15,3.25,3.35, 3.45,3.55,3.65,3.75},{0 ..38,0.43,0.46,0.49,0.52,0.56,0.59,0.62})*D5-H5,"") Hope this helps! In article , "Dave O." wrote: I have used the following formula in a commission report. =IF((D5<"")*(E5<""),LOOKUP(E5,{3,3.15,3.25,3.35, 3.45,3.55,3.65,3.75},{0.38,0 .43,0.46,0.49,0.52,0.56,0.59,0.62})*D5-H5) When the spaces referenced above are blank i get a "false" in the blank. Can I change it so the false is blank to keep the sheet clean? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| blank cells | Excel Discussion (Misc queries) | |||
| Grouped Sheets and Formating | Excel Discussion (Misc queries) | |||
| link data to new workbook | Excel Discussion (Misc queries) | |||
| Grand Totals @ Same Place | Excel Worksheet Functions | |||
| Paste Special in a macro | Excel Worksheet Functions | |||
Linear Mode
