I have never used Excel very much, but I was making a spreadsheet for cutsheets and have a question.
I am using the formula =IF((A3-B3>0),A3-B3,"") for the cut column
& the formula =IF((A3-B3<0),ABS(A3-B3),"") for the fill column
Where A3 equals hub elevation and B3 equals finished grade.
The problem is that the fill column displays the finished grade when the hub column is empty (because a blank cell equals zero). Does anyone know of a way to embed another if formula to keep this from happening?
thanks
Radar posted a cut sheet on the "other board" that does just that. Look under the "files" tab.
You can do multiple IFs - one to first test the value, and if it's non blank, then the second IF for the formula.
I tried to post the code and got an error....
Send me an email and I'll send you my cut sheet.
Or you can go to the other board and download it there.
Radar
email me and send you mine. Works great
i can email you what i have if you want it.
> I have never used Excel very much, but I was making a spreadsheet for cutsheets and have a question.
>
> I am using the formula =IF((A3-B3>0),A3-B3,"") for the cut column
> & the formula =IF((A3-B3<0),ABS(A3-B3),"") for the fill column
>
> Where A3 equals hub elevation and B3 equals finished grade.
>
> The problem is that the fill column displays the finished grade when the hub column is empty (because a blank cell equals zero). Does anyone know of a way to embed another if formula to keep this from happening?
>
> thanks
You could do a nested if like so:
=IF(A3="","",(IF((A3-B3>0),A3-B3,"")) for the cut column
=IF(A3="","",(IF((A3-B3<0),ABS(A3-B3),"")) for the fill column
That will give you blanks in both cut and fill columns when the Hub column is blank.
Thanks for the help!