To strictly combine your formulae you would have
=IF(ISBLANK(R32),0,IF(R32<12,1,IF(R32>11,1.5,""))), however you can streamline it as you will not get to the
"" for a FALSE result in the last nested IF statement because the last IF statement cannot be false.
The strict combination does what you want but you could use
What the streamlined formula does is first check to see if
R32 is blank. If it is then insert a
0. If it isn't blank then it goes to the next IF statement. If
R32 is less than
12 then insert a
1. If it isn't then it has got to be either
12 or higher so insert
I am a little confused though with your last requirement which was "if blank then blank". You already have the first IF statement inserting a
0 if blank. You need to choose whether you want a
0 or blank if
R32 is blank (no entry made). If you want a blank, change the
0 in the first IF statement to a
Another point of note is that to check for a blank I personally find it is good to use
OR(R32="",R32=" ") instead of
ISBLANK(R32), especially if you are sharing the sheet with someone else.
The reason being that I have lost count of the number of times someone has put a space into a cell to make it blank but it isn't. Excel will see the space as data as you have a character in the cell. This can cause confusion and lost time looking for the problem when you don't get the results you expect.