i challenge you all!!!

Driggs

New Member
Joined
Apr 5, 2006
Messages
31
not really.. im probably missing one small thing, but id figure i might save myself a half hour if i asked here..

i have an input in cell g22 and an input in cell g23. g22 is for a number if the pipe is 2" in diameter while g23 is if the pipe is 3" in diameter. the cells never will both contain numbers, just one or the other depending on the sites layout.

=IF(G22<>0,800/G22,IF(G23<>0,800/(G23*0.5)))

is what i have so far and the math works, but displays a false if there is nothing in cell g23 or g22. i would LOVE to have this cell (g24) display nothing if cells g22 and g23 are blank.

hopefully i didnt confuse anyone!

thanx in advance too. everyone on this board is such a help.

mike
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

PATSYS

Well-known Member
Joined
Mar 12, 2006
Messages
1,749
=IF(IF(G22<>0;800/G22;IF(G23<>0;800/(G23*0.5)))=FALSE;"";IF(G22<>0;800/G22;IF(G23<>0;800/(G23*0.5))))

Note: replace the ; with , as my pc is in european setting.
 

Driggs

New Member
Joined
Apr 5, 2006
Messages
31
fantastic! thanks so much.
i had tried something similar to that, but obviously it didnt work. like everything else you guys have helped me on, this will definatly help me out in the future everytime i update this massive workbook ive created.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,033
Messages
5,526,362
Members
409,697
Latest member
christopherlewis1620

This Week's Hot Topics

Top