Easy Office
LCI Learning

Excel functions

This query is : Resolved 
Avatar

Querist : Anonymous

Profile Image
Querist : Anonymous (Querist)
16 October 2012 if(a4:ae4>9, then it has to minus 5 from the all the cells, where the cell has grater than 9.

pls help....thanks in advance
Profile Image

CA CS CIMA Prakash Somani

Profile Image

CA CS CIMA Prakash Somani (Expert)
16 October 2012 simple:

=if(a4>9,a4-5,a4)


copy and paste this formula in all the cells...

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

CAclubindia's WhatsApp Groups Link


Similar Resolved Queries


loading


Unanswered Queries



Trending Online Classes

view all classess
CCI Pro


Answer Query



Quick Links