asked on Modify formula to convert zeros
Hi,
I would like help to modify the attached formula to convert zeros to 99
Please see attached
Convertzero.xlsxMany thanks
Ian
I would like help to modify the attached formula to convert zeros to 99
Please see attached
Convertzero.xlsxMany thanks
Ian
SpreadsheetsMicrosoft ExcelMicrosoft Office
Last Comment
Subodh Tiwari (Neeraj)
=C2+(C2=0)*99
ASKER
Hi Saqib nice to see you again.
Actually I wanted the attached formula modified to convert to zeros
Thanks
Actually I wanted the attached formula modified to convert to zeros
Thanks
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks, works perfectly, I now remember this formula from a while back. I am getting a bit old :)
Cheers
Ian
Cheers
Ian
Hi Ian,
If you have Office 365 and access to the new LET function, you may try something like this...
If you have Office 365 and access to the new LET function, you may try something like this...
=LET(val,INDEX(DFRMDATA!$A2:$TD2,MATCH(C$1,DFRMDATA!$A$1:$G$1,0)),IF(val=0,99,val))
ASKER
Hi Neeraj, I don't have 365 as I only ever use Excel from the range of Microsoft products.
Thanks though and trust you are surviving this pandemic out there in my favourite country..
Cheers
Ian
Thanks though and trust you are surviving this pandemic out there in my favourite country..
Cheers
Ian
Thanks Ian! We all are safe and healthy here in your favourite country. ☺