Need cell to be blank incorporated in my if statement

**jobuTupaki** · 05-20-2022, 09:23 AM

Hello!

This is my current statement: =IF(I55=120,Q55/(120*0.001),IF(I55=208,Q55/(208*SQRT(3)*0.001),IF(I55=480,Q55/(480*SQRT(3)*0.001))))

I would like to make it so if Q56 is blank, then so will the cell with the formula above. I tried using IF(ISBLANK(Q55),BLANK, *rest of formula*), but that didn't work. Right now, when Q56 if blank, the cell shows #VALUE!, and I just want to clean it up a little and have it blank.

Any help would be very much appreciated

Thanks!

**Sam Capricci** · 05-20-2022, 09:26 AM

try... =IF(Q56="","",IF(I55=120,Q55/(120*0.001),IF(I55=208,Q55/(208*SQRT(3)*0.001),IF(I55=480,Q55/(480*SQRT(3)*0.001)))))

not sure if you want it as =IF(Q55="","" then the rest of the formula that you can drag down?

**jobuTupaki** · 05-20-2022, 09:28 AM

THANK YOU!!!!!!!!! You just made my day

Appreciate it

**Sam Capricci** · 05-20-2022, 09:36 AM

You’re welcome, glad I was able to help.

Need cell to be blank incorporated in my if statement

LinkBack

Thread Tools

Rate This Thread

Display

Need cell to be blank incorporated in my if statement

Re: Need cell to be blank incorporated in my if statement

Re: Need cell to be blank incorporated in my if statement

Re: Need cell to be blank incorporated in my if statement

Thread Information

Users Browsing this Thread

Similar Threads

Format cells based on 2 separate cell data, incorporated into the format

[SOLVED] If Statement when Cell is not Blank

IF Statement to leave cell blank if multiple cells are all blank

Incorporated Until empty cell with sum function

How to copy the cells without any change in the formula incorporated in that cell.

[SOLVED] If statement that copies text from a separate worksheet, or if blank, leaves cell blank.

IF statement with time/hour incorporated

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions