SOLVED

formulas for returning values if another cell is blank

%3CLINGO-SUB%20id%3D%22lingo-sub-2508954%22%20slang%3D%22en-US%22%3Eformulas%20for%20returning%20values%20if%20another%20cell%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2508954%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20only%20working%20on%20one%20sheet%20and%20need%20a%20formula%20to%20display%20a%20value%20only%20if%20another%20cell%20has%20data%20in%20it%3A%20If%20D44%20is%20empty%20(or%20blank)%2C%20then%20G44%20will%20be%20blank.%20Otherwise%20I%20want%20to%20return%20the%20following%20value%20in%20G44%3A%20(F44*24)*D%241.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20sure%20if%20I%20can%20use%20IF%20with%20ISBLANK....%3C%2FP%3E%3CP%3EThank%20you!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2508954%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2508977%22%20slang%3D%22en-US%22%3ERe%3A%20formulas%20for%20returning%20values%20if%20another%20cell%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2508977%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1093530%22%20target%3D%22_blank%22%3E%40jstromb%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUse%3A%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIF(D44%3D%22%22%2C%22%22%2CF44*24*D%241)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2509071%22%20slang%3D%22en-US%22%3ERe%3A%20formulas%20for%20returning%20values%20if%20another%20cell%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2509071%22%20slang%3D%22en-US%22%3EIt%20is%20valid%20but%20ISBLANK%20will%20only%20test%20for%20empty%20cells%2C%20not%20ones%20that%20have%20a%20formula%20that%20returns%20%22%22.%20For%20that%20you%20could%20use%3CBR%20%2F%3E%3D%20IF(%20D44%26lt%3B%26gt%3B%22%22%2C%20(F44*24)*D%241%2C%20%22%22)%3C%2FLINGO-BODY%3E
New Contributor

I am only working on one sheet and need a formula to display a value only if another cell has data in it: If D44 is empty (or blank), then G44 will be blank. Otherwise I want to return the following value in G44: (F44*24)*D$1. 

 

I'm not sure if I can use IF with ISBLANK....

Thank you!!

4 Replies
best response confirmed by jstromb (New Contributor)
Solution

@jstromb 

Use:

=IF(D44="","",F44*24*D$1)
It is valid but ISBLANK will only test for empty cells, not ones that have a formula that returns "". For that you could use
= IF( D44<>"", (F44*24)*D$1, "")

@Hans Vogelaar , thank you so much! this worked beautifully and is so simple!  I appreciate your quick reply!

-jstromb

Peter, thank you so much for your quick response! I really appreciate your help!!
have a great weekend!! Happy 4th!!
jstromb